To run the Ingredients Used in Products report:The Ingredients Used in Products report shows products from your product list and the chemical ingredients of each, including each ingredient's name, CAS number, and amount within the product.For each product, the report output can show—in addition to its ingredients—any or all of the following data:
Common Name
Manufacturer
Revision Date
Internal ID
Primary CAS Number
File Number
Language
You can also enter criteria for any of the following data types. The report output will include only products that match your criteria in their corresponding data fields:
Product Name
Manufacturer
Internal ID
Ingredients
User-Defined Fields
Location Assignments
Products with no recorded ingredients are omitted from the report.
The report output can be generated in any of the following formats: HTML, PDF (requires a PDF-viewing tool, such as Adobe Reader), or Excel (requires Microsoft Excel).
To run the Ingredients Used in Products report:
Starting at the Reports page
In the list of Product Reports, click Ingredients used in each Product.
The Ingredients Used in Products Report page opens, showing the options available for this report.
In the Report output menu, select the desired format for the report output.
To include products no longer used (archived products or products no longer in use at a selected location) in the report output, select Include products no longer used.
Note: If you select this option, each archived product in the report output will be marked with a red asterisk (*).
To generate the report using default options, skip to step 6. To define options for this report, click Click here for advanced options.
A Report Options area is added to the display.
Enter the desired report options in any or all of the areas provided:
Title: Enter the Report Title and Report Description you want printed at the top of the report output.
Locations: To focus the report on products at certain locations, select the desired location in the menu provided. Repeat to select multiple locations. The report output will include only products assigned to one or more of the selected locations (or to their sub-locations).
Fields and Sorting: This area shows the data fields the report output can display for each product. First, use the Add and Remove buttons to add all desired fields to the Fields and Sort Order list and remove all unwanted fields to the Available Fields list, respectively. When the Fields and Sort Order list contains all (and only) the desired fields, select a field and use the arrow buttons to move the field up or down in the list. Repeat until the fields are in the desired sort order. The report output will be sorted firstly by the first field in the list, secondly by the second field, and so forth. (Example: If Manufacturer is first in the list and Common Name is second, the products in the report output are sorted alphabetically by manufacturer. If two or more products have the same manufacturer, they are sorted alphabetically by common name.)
Criteria: In the fields provided, enter one or more criteria. The report output will include only those products that contain all your criteria in the corresponding data fields.
Click Generate Report in the upper right.
The report output generates according to your chosen options and opens in the selected format.
Related Topics